SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 287988 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 287988 [ RunTime:0.001792s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (264923,214570,994959,1025540,657741,319811,635276,775707,775371,201322,579825,224985,204192,248250,363365,771253,315251,172588,25816,656713,699985,254394,466579,959198,676407,746973,410282,35077,790103,182354,922921,402464,98234,647932,983160,801699,870721,39329,425841,366152,43981,675353,636612,785804,417289,48193,59993,886149,332828,344356,129471,342608,812913,864329,293703,887456,206023,847543,983429,280840) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001013s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 287988 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 287988 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000486s ]