SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001286s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 41438 LIMIT 1 [ RunTime:0.000427s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 41438 [ RunTime:0.003487s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (984981,939805,78042,1010393,281847,160047,861003,966549,946382,160711,867582,930663,822244,299425,441250,678621,261483,751463,561829,617620,1020340,882411,138990,921890,1041630,59111,695078,759037,214360,794211,332232,161028,639689,586637,842554,859464,908126,619929,677007,867093,992675,793816,1015813,47225,721480,87706,219595,154195,100221,916823,734111,713979,400012,283994,316424,92751,350667,738825,925259,724875) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 41438 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000462s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 41438 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000621s ]