SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003621s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 544071 LIMIT 1 [ RunTime:0.002022s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 544071 [ RunTime:0.002212s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (846061,75479,557708,192237,483248,157485,712064,453887,830916,115848,912528,222153,842762,693256,189261,552870,286390,285224,899874,240698,631496,421899,68774,172953,596788,513674,592969,544342,173567,101449,941949,232980,904742,621421,766292,137377,504577,577405,318426,572916,318166,1038760,717739,264521,542886,374423,875212,690750,968952,976949,985184,299779,597579,191589,331690,689929,558308,524878,331920,347533) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001104s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 544071 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 544071 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000588s ]