SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001250s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 419313 LIMIT 1 [ RunTime:0.000389s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 419313 [ RunTime:0.001513s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (932448,752531,194614,421673,393420,210253,225332,994888,440219,547438,763784,11316,389885,484298,233510,242434,1035755,255374,672550,689699,805614,433416,428013,138912,1000014,170988,130596,277032,201151,617204,92028,270230,174086,933252,738498,543522,979455,812218,465366,455693,646069,326692,482456,933723,915372,595543,806654,459918,294894,885848,589732,1025631,54562,955270,947888,583085,1029763,48195,353658,837550) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001600s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 419313 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 419313 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000377s ]