SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003377s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1042612 LIMIT 1 [ RunTime:0.000443s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1042612 [ RunTime:0.003105s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (42105,859182,90903,862380,970542,1023472,926166,562199,859709,340041,173188,672125,796588,831940,150481,981664,388890,481853,881274,116686,968558,481774,992201,106381,842001,1048616,483487,960018,687446,465131,190337,986502,789170,817801,53939,1022230,754348,1019226,955389,854224,126670,455526,727069,933014,529743,96959,504771,187242,102259,986466,819843,132711,697320,369930,123055,127910,493764,843629,44620,340599) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1042612 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000493s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1042612 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000667s ]