SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003007s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503009 LIMIT 1 [ RunTime:0.000407s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503009 [ RunTime:0.003141s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (689260,406588,273145,54326,998087,456640,339697,735429,74820,966152,850487,347046,1047641,92161,844964,1023625,816640,977559,1020368,705439,49105,891091,534840,678272,355704,963379,133698,183994,759599,114488,511783,374117,533942,42560,670944,195426,45347,506579,487650,349077,50880,1010921,32322,868939,361929,860219,595027,707665,922013,701558,600578,313248,879159,1034786,453557,138364,1033786,157331,203326,525972) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503009 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000497s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503009 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000389s ]