SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 523004 LIMIT 1 [ RunTime:0.002970s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 523004 [ RunTime:0.001617s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (445655,443106,421753,581064,490224,536410,594902,282436,179545,28118,488395,396233,711144,482533,225887,868639,290428,797392,845922,164307,308812,810577,1017753,96884,360224,64414,34988,776645,972147,890511,214011,754237,917918,441443,998303,1006244,856235,153829,218017,764412,142470,370439,349287,156573,896929,772172,866387,717167,1047687,277925,46250,606969,607700,289719,140342,34425,814532,19572,755641,545465) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001066s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 523004 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003812s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 523004 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000396s ]