SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 861048 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 861048 [ RunTime:0.002560s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (350520,328813,310256,840942,24354,148321,531902,491003,936168,780096,551167,979157,655056,720198,703506,497596,355268,899794,854757,45619,257596,430630,902058,291625,974223,222755,100155,821965,888950,415157,638406,567666,725895,619526,220319,767134,995350,701124,748366,675813,1027094,51283,1044368,25049,949777,743000,716080,852863,70585,720305,480098,84512,406029,178972,247636,183228,365073,222882,167670,718656) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 861048 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 861048 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000622s ]