SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001370s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 48152 LIMIT 1 [ RunTime:0.000464s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 48152 [ RunTime:0.001868s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (160374,486505,404499,181856,1007831,671452,223665,802785,698211,909873,104757,904210,899627,224872,985531,918328,274680,246410,931309,62538,577333,536791,499516,343209,892766,885774,707429,865542,1000651,400042,328877,472207,982891,373000,47500,1018419,464216,931037,411229,384126,881948,148464,850147,389767,257860,579007,827220,407628,966715,693357,42575,34922,463740,414242,803066,16956,384068,125840,111460,554875) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001302s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 48152 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000438s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 48152 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000594s ]