SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001381s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 552718 LIMIT 1 [ RunTime:0.000682s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 552718 [ RunTime:0.003163s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (500311,1044749,912137,754037,636029,996807,841459,826927,174832,851023,1043281,291471,312100,360889,78329,330910,149665,783167,100187,707794,19552,693810,879688,775396,130809,686419,217188,874661,477934,404497,6557,520401,675705,1027603,7388,210245,825855,511639,922544,705083,850707,385377,352849,941604,44411,532047,28575,544629,212631,130111,783723,926986,839243,356038,145991,909146,928259,731060,347727,66940) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001104s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 552718 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000493s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 552718 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000676s ]