SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001680s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1021089 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1021089 [ RunTime:0.004215s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (275881,612172,851394,964425,682367,729873,211091,237841,21854,281290,160679,101990,174399,791911,917866,767584,299426,819935,201768,918882,942456,391149,864951,538154,952670,712173,339267,918909,872360,338510,711846,297290,752503,425384,650188,257007,65381,802670,293333,460398,1033937,919437,507051,992799,823201,558138,222643,866466,991301,1046520,199365,929661,911196,96695,772331,159057,470990,368163,138508,887658) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001659s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1021089 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000441s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1021089 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000588s ]