SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 341812 LIMIT 1 [ RunTime:0.000430s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 341812 [ RunTime:0.001661s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (862264,480043,967934,707201,151435,582344,156810,66250,543338,964176,234244,407705,847514,328145,473358,401372,410652,590954,618462,861739,814586,915334,664499,737590,753004,906184,564851,481144,50011,953530,374557,380164,958337,378222,706777,410978,114542,37394,63100,753744,33238,794078,26040,128166,428083,397329,476902,21550,874675,189363,252266,1041889,821009,99801,746177,950079,616471,53227,425466,669089) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001020s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 341812 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 341812 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000452s ]