SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1034142 LIMIT 1 [ RunTime:0.000545s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1034142 [ RunTime:0.001643s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (295106,167568,617171,272612,44362,960452,674878,747567,48676,396614,257484,196089,427741,15152,98492,886515,464498,673130,422708,77600,295984,899262,166247,878352,354956,220801,624943,253451,24580,212151,533674,312422,1008006,544263,671140,1007152,944374,604645,1010944,890849,872598,892488,957415,683651,445208,495119,642042,677106,781357,738952,365512,371110,83078,448216,526805,948022,910707,309459,897351,519838) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001070s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1034142 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1034142 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000561s ]