SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001298s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 447451 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 447451 [ RunTime:0.001561s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (215692,106102,994087,111654,719523,797011,767293,381321,464413,757136,875334,750721,173418,812333,734765,717903,779907,296531,218740,755654,1031906,682626,982221,627846,994111,310763,369295,329093,795855,38229,231578,303934,567599,826012,1024241,720331,878788,607588,993607,834433,816332,1020927,628517,71930,666243,800068,985002,518543,985534,1007866,336002,181507,729772,447696,171747,975513,136071,56893,469906,122528) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 447451 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000423s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 447451 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000636s ]