SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001293s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 901974 LIMIT 1 [ RunTime:0.000475s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 901974 [ RunTime:0.003319s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1000164,786424,384740,13643,110159,935117,448019,332314,888046,302542,53901,330976,999512,24382,317901,377515,1015132,233760,541407,423593,387519,130921,1030514,506368,750490,742914,940324,175974,302560,329130,745606,236210,726206,715733,747904,718610,787965,313355,53521,415760,709600,270191,627083,755247,101543,840606,714036,575851,663371,880645,508520,94468,623322,758897,213646,444184,818402,951150,810651,433358) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.023977s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 901974 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000605s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 901974 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002851s ]