SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001573s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 472008 LIMIT 1 [ RunTime:0.000448s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 472008 [ RunTime:0.001967s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (701190,400253,242837,294960,18828,37363,342066,826138,946423,869145,294690,654661,332195,430114,375846,651704,461113,496683,200854,102708,312691,228957,435523,123729,297192,830754,249939,587003,551166,134753,814252,422671,452847,59782,162030,258756,44781,243842,497931,452173,884435,684616,700935,262530,418326,553547,369035,779570,986820,114280,634508,458117,505408,349641,422333,278189,461106,173762,530753,560016) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001569s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 472008 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000434s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 472008 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000547s ]