SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001168s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 338518 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 338518 [ RunTime:0.001929s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (581478,593670,877984,480977,210936,73543,569397,687059,219025,601755,42981,867371,407394,109121,283529,1651,933625,401501,276274,561025,650972,558671,372740,524133,84390,909024,509213,894688,394512,380771,208548,268854,544540,732872,863203,787652,755012,663650,203935,374901,833447,586375,526419,127933,45613,212234,191151,514526,997987,506122,1025084,13511,399626,722461,767193,421120,363103,726521,654080,331522) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 338518 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 338518 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000484s ]