SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504290 LIMIT 1 [ RunTime:0.000394s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504290 [ RunTime:0.001488s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (950871,189924,1039301,366158,54319,542972,592431,806448,275868,948494,740697,13258,51754,443987,210036,921235,732493,901680,155879,915630,5566,627365,188437,439675,644696,632179,20908,935320,656392,211780,917865,547094,322395,747227,793119,106368,917979,874290,948019,418441,141075,395534,426590,56074,485574,1028218,792779,804564,430842,1034825,98846,337306,348169,75937,211651,287464,70287,979288,686243,5851) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001052s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504290 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504290 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003935s ]