SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002787s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 196080 LIMIT 1 [ RunTime:0.000831s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 196080 [ RunTime:0.003034s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (899882,19856,424072,465212,71255,234663,285812,549697,165626,167932,281452,384337,71047,747048,127686,519022,194572,144594,295037,439457,38575,241642,570129,156442,448381,721736,699281,948995,398997,90911,592366,905144,634190,364599,506637,927181,993023,287505,666781,29880,782488,1033359,627946,459583,517203,567030,599425,397221,52698,547501,544197,94822,748605,471864,649992,953877,581058,166483,75035,239338) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001265s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 196080 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000437s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 196080 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000589s ]