SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001448s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 263638 LIMIT 1 [ RunTime:0.000537s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 263638 [ RunTime:0.001775s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (97819,536803,448676,349570,938598,692413,822290,433525,342750,263171,775752,1025602,988810,735563,276791,85782,1040076,742695,744326,371557,189161,641661,64509,513287,426522,130277,224509,655257,571429,759321,582398,640969,1041547,102633,46081,604654,132660,826190,74393,1022910,932691,84172,626600,511356,43368,514170,506984,530606,470465,463374,420264,469016,540342,74625,215882,329189,20829,981678,13787,216633) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 263638 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 263638 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000641s ]