SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001318s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 483131 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 483131 [ RunTime:0.001623s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (512708,859272,763341,1029744,198506,789748,461257,298935,571069,508581,52347,111913,682613,144041,316536,391372,285531,1047010,43854,463489,184331,327644,251737,875361,758108,563399,619368,346302,680228,822424,196368,422781,110799,933144,1020549,434321,192661,446450,940458,960067,1037365,927332,945640,743637,573572,331577,261358,1039104,240728,225370,654027,950520,391217,946272,511239,1027518,576834,651973,89979,419262) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 483131 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 483131 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000626s ]