SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501175 LIMIT 1 [ RunTime:0.000303s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501175 [ RunTime:0.001999s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (774391,44802,794489,131996,342831,331916,693982,716111,75677,1004322,798811,208710,1019792,105427,25571,182242,372222,848883,542918,294362,1000909,487945,763485,966728,358023,818338,504937,951616,918923,768276,490605,431660,456668,5795,902769,714647,328561,518571,332510,746234,830494,271380,460198,763606,358024,28262,201799,109363,870457,242897,515897,337565,809111,798569,13833,843368,295962,450267,45088,714767) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000905s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501175 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000343s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501175 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000452s ]