SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002774s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 47535 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 47535 [ RunTime:0.002473s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (815341,353157,775419,450099,148927,466994,229070,174550,728818,368443,900491,925151,413839,376536,289810,656190,172816,25917,540085,435208,753467,521080,294028,629826,744196,32350,198160,878947,646097,493480,83609,760930,346403,27325,772729,939111,715368,778246,836086,681650,675747,982292,309774,115310,133038,842522,509457,157201,2912,137980,21139,204642,760622,346184,760102,602268,585577,263159,257964,990649) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001039s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 47535 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 47535 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000577s ]