SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002646s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1023247 LIMIT 1 [ RunTime:0.001654s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1023247 [ RunTime:0.004757s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (379398,457485,198274,977242,342554,745512,248439,406241,910021,190789,65670,753841,908506,670941,157543,427500,433448,888992,458906,799261,688037,558238,728625,724315,628681,908389,877216,133096,791834,231912,1014117,1042893,655996,428006,336773,531741,359032,1007338,86822,1047492,680846,519334,394221,930140,224720,176937,900507,296831,919912,443059,429321,1004299,671123,201305,107964,853519,387205,694082,909571,32899) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003327s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1023247 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001822s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1023247 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004741s ]