SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.005604s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 249003 LIMIT 1 [ RunTime:0.000717s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 249003 [ RunTime:0.001986s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (341400,416240,464538,613322,761046,886724,317984,863350,590944,1010169,677541,938080,607913,902357,521901,531033,984012,753403,256204,815827,171695,953317,235789,1012590,368720,1001404,829722,151414,443166,911129,256577,138751,727442,749090,562804,832280,417850,62040,354786,311026,110752,838531,256337,262451,1000993,337956,946884,306649,922073,167026,369100,543922,714013,598779,762499,871377,525577,341967,682745,340389) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002705s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 249003 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001884s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 249003 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000461s ]