SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 200924 LIMIT 1 [ RunTime:0.000381s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 200924 [ RunTime:0.001571s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (541482,85029,996027,118142,53787,143904,784156,986327,520728,215831,817986,618100,1026328,692524,514266,570247,947196,137828,979590,718999,868959,586737,157310,768878,809052,238225,259531,1018503,680681,273730,298480,357549,703728,887120,343866,674611,421671,753352,641544,55475,166717,520502,424746,920844,256875,352771,336099,1009998,491000,878376,696485,827321,529726,289346,659388,648204,718197,849397,219648,712899) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000958s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 200924 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000336s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 200924 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000560s ]