SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001013s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1042661 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1042661 [ RunTime:0.002203s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (991937,319964,503963,337257,977474,116816,891532,261167,118152,471386,796898,620843,1004384,122056,975530,25090,44711,1038516,1000641,106977,364045,398160,1020021,663487,795536,345344,1014980,740019,3479,438183,160501,480950,22594,193529,665880,576272,36130,190749,685872,931096,332456,71398,852409,584778,374747,311503,833952,940783,352044,1028802,78922,773545,311632,811739,837689,536753,467764,13056,731895,752487) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001051s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1042661 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000452s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1042661 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000624s ]