SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 438650 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 438650 [ RunTime:0.003784s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (981572,78808,356796,941001,933577,25827,864801,155838,299799,33132,59233,903889,629807,634515,26655,431149,200287,904542,644379,249080,769814,93481,671895,925896,512239,795768,261597,390927,493636,242011,332239,25623,460254,46530,53439,290010,998246,575350,63085,5851,210804,651229,484593,171107,538187,485432,733990,610465,380947,231658,740822,57514,784452,844125,1039611,831947,360054,219576,433412,745530) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001251s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 438650 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000439s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 438650 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000584s ]