SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 407045 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 407045 [ RunTime:0.001529s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (610604,1028424,22295,657511,802578,370620,245195,16949,234445,453317,802707,659081,254571,285578,239113,807585,803958,378674,108544,854438,35323,733231,653413,40426,612950,673538,311582,87857,785272,160945,28514,225328,1024295,711083,487888,226853,800075,526531,131778,313576,392630,56444,548087,179890,606527,316411,395771,6823,44584,83358,758352,90193,803986,103472,882298,474685,64146,231276,61429,430060) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000961s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 407045 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 407045 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000516s ]