SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001088s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 801004 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 801004 [ RunTime:0.001728s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (416764,689137,727234,554622,603485,468180,991591,475014,32615,411802,71537,605471,570029,769555,731063,550070,150316,500420,1012745,244237,168394,342933,251811,22473,844510,938865,135165,747940,409353,645272,132783,62858,809699,869631,708732,517570,125469,482080,891388,506774,1043464,130761,494469,529106,725735,628855,561373,848139,534437,534783,1037942,312337,141359,363584,752597,619195,621527,782862,92865,555421) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001107s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 801004 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 801004 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000500s ]