SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001262s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 473841 LIMIT 1 [ RunTime:0.001259s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 473841 [ RunTime:0.001599s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (822227,571213,931684,858014,128175,253051,176577,251589,515168,319787,492322,1015966,661684,176266,261607,898061,383711,686695,50443,811304,621982,300792,123244,523687,398146,815927,476143,579049,137461,773971,731173,422530,453581,809013,701113,117635,336154,387338,767380,1034212,520154,906780,592851,37051,293443,964855,248606,333557,170107,491862,584007,435244,44230,763590,135111,631438,819053,75889,638463,634419) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001517s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 473841 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 473841 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000663s ]