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` = 144961 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 144961 [ RunTime:0.001732s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (874470,829719,449201,397823,782499,829757,782460,50417,986730,472754,106890,353512,109155,511679,310964,569274,391784,1022408,672605,949008,804192,638998,196183,635642,778692,815060,207342,28347,337761,19049,786723,134220,928024,950890,107443,56857,286104,236122,565068,710437,398514,513287,221527,69695,67276,307444,543637,742231,814140,296273,569763,324447,705702,917786,728626,408461,391735,369512,13280,898752) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000950s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 144961 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 144961 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000547s ]