SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 667451 LIMIT 1 [ RunTime:0.000413s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 667451 [ RunTime:0.001717s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (101434,595512,337503,505654,78959,869174,513893,889209,323359,501604,949033,342342,392991,138183,467492,912345,228714,212141,641760,152091,501311,954815,991680,219533,740778,6323,751145,432800,644639,973544,560362,268020,422143,753882,450871,717022,502507,400361,188660,684380,13974,134568,523433,153268,610909,966892,165740,256855,404036,383506,171912,440436,491937,111996,32231,848908,1016338,39005,72975,643360) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 667451 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 667451 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000532s ]