SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000934s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 414328 LIMIT 1 [ RunTime:0.000545s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 414328 [ RunTime:0.002431s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (155068,833968,970214,411721,722077,463768,322475,1021818,375423,128602,803675,939990,152118,299294,336504,148904,501474,31658,471027,1035420,104181,224547,149221,640383,661763,215392,987545,1043587,14312,870267,268138,298598,251897,876592,394185,963841,439521,519464,265986,259847,531025,212322,953872,902497,137144,368903,490963,493815,680682,772460,588953,210547,124476,186923,501173,132013,965533,89789,466364,638928) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001596s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 414328 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000453s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 414328 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000475s ]