SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001891s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 326928 LIMIT 1 [ RunTime:0.001202s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 326928 [ RunTime:0.003968s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (478327,192685,363208,418940,59821,576014,811644,243471,909398,808912,474149,1043946,506331,470749,810164,649597,688216,137718,953099,229335,47580,764671,705428,690601,373178,818995,185252,833646,924621,195505,257707,794544,757845,535270,1038911,523552,603982,666473,521440,819129,751481,7539,902172,8068,822506,902892,144044,831474,341200,894011,844798,829675,294103,959422,980188,77751,460016,59601,416881,590889) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001826s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 326928 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000545s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 326928 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003753s ]