SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001392s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505752 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505752 [ RunTime:0.001854s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (168504,749630,509266,188358,188708,277002,699612,893875,1030131,42177,1016335,44100,892304,1016355,649977,315132,490591,205602,1039227,381595,664317,614841,1003416,812245,9195,926194,501750,1038947,8364,929511,43254,558368,428116,983689,163708,531635,389790,993832,759811,211862,702597,567022,1006504,932523,516198,379426,366698,543335,596720,147269,920629,590243,418296,608434,337531,173323,47512,1036068,573626,887470) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001101s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505752 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505752 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000581s ]