SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003912s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 801599 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 801599 [ RunTime:0.005656s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (422460,280341,968970,648182,160647,353012,450549,401951,177561,679220,242391,929803,121,872902,63512,99316,218185,256852,178708,144884,264577,503117,74982,467190,173515,146637,774966,366006,996975,189158,884665,578190,1046543,380796,114789,4468,464731,364485,916857,451063,889326,390521,762711,762218,1041070,429535,481589,144854,352414,727673,356313,769986,918678,1020700,811483,479947,343951,897081,98189,72198) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001108s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 801599 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000448s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 801599 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000623s ]