SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001302s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1004317 LIMIT 1 [ RunTime:0.000520s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1004317 [ RunTime:0.001659s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (99889,407020,13229,59961,531809,31368,269128,191405,902000,578425,449016,456546,196218,736562,818976,151434,219077,53810,175861,993487,551402,21013,520927,694544,30898,394373,869850,324585,780369,477215,379443,155958,21779,976599,1026803,590714,1010995,593937,524527,342250,932732,746955,890571,694572,1047278,352691,264629,176850,1037980,360661,987965,321018,963241,603528,459120,566812,759654,901999,515262,763802) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000996s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1004317 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1004317 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002107s ]