SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 316968 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 316968 [ RunTime:0.002099s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (862176,604385,260954,933504,385693,876055,396644,610475,112057,671779,858379,422017,122119,377934,739881,651102,196763,235154,820024,73583,441556,823853,640881,265881,714991,392179,599631,993783,687518,251455,549245,648279,937229,761615,128659,920062,630953,173933,60007,581626,562449,44687,586976,346740,584585,128500,991424,893582,307157,782707,392465,208137,802815,1022041,930857,364345,447573,226059,1041501,286016) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001511s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 316968 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 316968 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001050s ]