SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001249s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 102505 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 102505 [ RunTime:0.001895s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (257301,841602,426648,677447,899848,892386,15426,246066,264953,954859,595389,874318,319981,841711,393966,954941,97142,477452,698505,707835,670947,734734,844370,851144,162005,296631,504745,34676,22846,937428,525710,821833,981723,572696,126114,156181,144283,695794,959731,269696,407184,480550,844541,115401,694592,323677,163820,890417,512206,385966,792712,95053,454003,209685,125439,264912,891112,177098,457536,296865) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001095s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 102505 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000556s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 102505 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000592s ]