SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001381s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 295923 LIMIT 1 [ RunTime:0.000592s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 295923 [ RunTime:0.002266s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (647713,35168,221438,137145,779747,894868,90077,391981,34376,1000164,966415,177673,1029185,364379,658695,5113,876242,938267,93055,104322,335625,629145,642550,146454,31794,133915,858985,1008562,838503,715724,851592,183384,137769,74131,67726,431547,841092,839196,231820,778762,773153,744853,275353,252978,954565,92456,363825,961346,658975,409492,921434,334416,703687,916881,641423,152897,341318,110449,900138,701002) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001541s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 295923 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 295923 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000579s ]