SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001483s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 570583 LIMIT 1 [ RunTime:0.000783s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 570583 [ RunTime:0.002544s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (25691,870730,1013673,958405,408445,490781,345449,506063,927104,689062,234948,892544,61876,539640,214347,648841,529693,515523,926091,835413,704343,562158,41050,918127,5899,333682,647551,785878,709558,253782,639862,60856,559894,94911,130966,390700,769651,511569,436784,911669,26954,994601,948645,144477,726163,294437,162776,177335,378910,931165,335154,273244,568481,768261,53137,119124,930806,205649,165937,230008) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001302s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 570583 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000451s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 570583 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000568s ]