SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 372800 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 372800 [ RunTime:0.001439s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1037075,511785,188031,551737,764672,1011113,920488,163450,970172,318304,195076,200940,413894,304158,49052,243471,695146,994701,148212,812342,969719,950318,591798,595091,85992,1039666,1046899,514425,242224,461473,915785,512105,747621,987863,268841,1000072,947246,1043602,300992,47797,1031236,221906,162695,48547,298376,940418,235905,826976,867867,506901,12619,807609,451980,254107,860989,790549,281352,410677,607204,198197) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001012s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 372800 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000594s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 372800 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000556s ]