SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 415964 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 415964 [ RunTime:0.001712s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (866496,736265,940711,416135,876320,751906,154563,629533,1005318,177173,114061,462032,130065,563149,396890,272182,882685,206213,496798,83813,102827,226851,812199,538183,670746,661577,109803,647913,703436,741962,706304,665328,421539,785373,704176,362994,9098,1035379,387736,1034256,101719,621497,160576,726660,80535,383877,564786,920795,824148,658790,398398,727299,775680,107584,1022582,32460,225764,115826,301761,523586) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000928s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 415964 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 415964 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000460s ]