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` = 121258 LIMIT 1 [ RunTime:0.005686s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 121258 [ RunTime:0.002418s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (514089,269687,17857,980766,498147,864428,822237,214687,161037,584368,661139,168077,35674,118550,229694,263639,458410,336750,27832,33145,458604,862280,768147,696928,333665,433936,783035,824406,839945,1012953,1038928,62148,1033462,325160,331037,394470,453587,340260,1025642,204611,821942,331241,334732,581634,470565,196953,225670,927186,429994,645792,222191,35508,542003,30744,79367,425267,349486,812662,671893,474265) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004906s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 121258 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003186s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 121258 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001215s ]