SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503589 LIMIT 1 [ RunTime:0.000462s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503589 [ RunTime:0.003555s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (982220,62949,350120,582693,942458,829133,925479,906517,6377,555244,22990,814610,63511,23130,862559,253719,656260,450453,969053,121188,436523,267987,76311,417479,761030,885841,998462,881923,734718,380189,278202,553939,683469,587545,670393,972715,19667,31129,538242,345095,86299,468605,562124,893255,203968,280497,466537,107859,330189,655661,21745,6988,626929,275968,756272,481444,148027,6340,229731,10561) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503589 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000427s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503589 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000517s ]