SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001304s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 345640 LIMIT 1 [ RunTime:0.000489s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 345640 [ RunTime:0.002560s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (433952,444993,130042,389412,684856,340500,153751,170971,88029,908953,487547,452362,29760,715856,367256,16958,314705,267979,311005,768748,822157,15483,430753,110508,242343,139193,76438,408146,241460,138489,44243,391476,616856,832211,801263,298244,59021,631080,398602,63427,763053,168739,115515,996684,951673,14796,438646,566561,337961,1021549,288054,787062,144702,32747,625835,147491,93069,448907,2739,762335) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 345640 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 345640 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000606s ]