SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001331s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504504 LIMIT 1 [ RunTime:0.000418s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504504 [ RunTime:0.002087s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (303206,153648,34817,1048563,435275,864561,570244,481916,694213,309580,734067,640477,574496,1042487,323370,343271,907924,727929,258044,451950,651793,471922,261540,1030719,197433,745843,261849,321842,848540,995760,109835,253398,826535,797336,244419,240201,872491,303575,693750,277031,449589,783087,698025,177018,489497,903145,290740,443059,96203,34754,177523,61177,296998,481469,350139,721308,94819,598434,518704,718899) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001622s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504504 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504504 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000545s ]