SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1805 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1805 [ RunTime:0.001899s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (36103,217535,308713,596332,112100,1024712,263280,921417,164578,836481,216623,42696,208062,263519,324570,158063,305613,912789,825414,675226,755870,539429,445791,220085,877178,577547,147330,63995,517048,142631,995367,348729,299380,1034553,963103,408696,428982,606224,594197,158552,253375,129386,338642,366998,863660,140546,5701,894400,29424,554092,813293,832932,502386,715554,791834,1042909,71168,947515,209171,386210) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1805 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1805 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000582s ]