SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.005331s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401314 LIMIT 1 [ RunTime:0.000846s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401314 [ RunTime:0.005902s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (559581,50849,1041300,11584,703265,897264,104451,697935,123228,300170,243166,1032988,292918,377462,978665,1025333,823008,781772,528525,13660,76540,211020,914691,163065,619461,56703,31675,580288,170999,319629,4474,643098,802549,279791,679016,424151,854541,260623,332146,555271,217290,746547,215248,756311,722507,270947,52284,176511,533854,60913,396737,111835,807672,367002,297179,436271,743972,33490,623335,1045650) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006247s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401314 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003288s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401314 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000640s ]