SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001686s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 430043 LIMIT 1 [ RunTime:0.000419s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 430043 [ RunTime:0.001857s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (417228,614294,607121,332741,72593,104898,666288,853821,180520,367164,650372,998444,982562,833665,13432,243965,870599,580664,580580,667828,119277,689116,106557,583666,990280,1008954,756075,551814,1035275,120712,869482,650477,676853,983692,13217,829376,129861,635767,167913,263344,1004832,53211,86426,76986,889166,798864,18845,898942,403364,218239,199736,597330,264025,630800,118836,998795,875964,477586,460591,780357) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002287s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 430043 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001658s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 430043 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000650s ]