SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001304s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 473260 LIMIT 1 [ RunTime:0.000451s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 473260 [ RunTime:0.001841s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (860158,375805,131157,25007,964152,701295,184052,929170,2422,356392,792572,1006422,837122,1010505,739843,344500,598024,188776,623831,44385,271216,524184,90998,665568,480619,772809,1034909,660124,658268,244336,354517,97152,147080,1000903,941848,856299,200248,488828,170280,907119,487492,385138,233024,738543,641280,524744,768094,125381,453027,95997,207483,660663,702943,173669,622431,810282,363684,40810,948063,440833) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 473260 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 473260 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000566s ]