SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501024 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501024 [ RunTime:0.001713s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (428504,383506,974974,42375,1020316,703605,750102,574622,654052,559739,491490,446470,401755,268496,952908,390479,349088,276304,36303,517607,242868,704452,972013,129542,840503,494697,864417,75109,110567,552088,856526,143851,222252,801976,819360,183082,277666,777913,12266,302548,13478,682057,1027130,113613,623304,372512,1038123,304983,70979,11821,418832,205295,431347,987825,836823,319991,415830,725275,527169,647636) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001293s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501024 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501024 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000649s ]