SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 514714 LIMIT 1 [ RunTime:0.000305s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 514714 [ RunTime:0.001946s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (804408,405017,206986,829310,857739,109651,690305,165805,801459,306264,516142,467688,293672,945241,1039417,323096,506899,156928,982415,533812,821193,237006,603335,849972,305035,405725,201714,286614,549712,1003875,293272,1018341,283410,775578,86657,996659,936563,468451,342063,664996,138052,21194,1028399,208439,793899,187226,41611,20839,26828,743238,1008764,121263,416434,816090,871724,157964,770066,116192,632989,655844) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000964s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 514714 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000426s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 514714 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000585s ]