SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001305s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 650618 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 650618 [ RunTime:0.001677s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (509594,405885,760528,892140,160964,447134,1008571,519166,409270,828181,45910,33349,1028491,953178,1021022,905191,461226,117838,536263,392540,856415,101314,46444,944288,56786,247634,352455,412253,318672,220508,469814,888004,182716,436550,1013165,665092,587434,354062,102945,43096,819145,231361,637855,640490,1006999,1043922,934886,292728,735112,25779,747121,745805,17034,136362,196645,556132,209400,38618,284821,118992) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001799s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 650618 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 650618 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001143s ]