SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001267s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 264307 LIMIT 1 [ RunTime:0.000389s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 264307 [ RunTime:0.001577s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (820595,224673,87321,107985,637704,157169,517059,203681,374409,78826,282671,855050,548665,520942,941629,339071,159666,365792,127522,971911,1007442,274618,651325,684962,312599,155690,408344,551121,270533,238221,182594,556338,249316,551903,786347,932611,342503,436148,421039,106026,868944,710254,763569,149760,1042053,940399,301065,629721,657211,932099,1041152,350821,1012970,1034729,46656,936279,88170,317807,67437,750356) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001032s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 264307 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 264307 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000555s ]