SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001252s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1042262 LIMIT 1 [ RunTime:0.000437s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1042262 [ RunTime:0.001814s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (126261,1005160,824613,10917,393205,289232,53690,4763,1007963,7085,32721,1013111,600669,744107,305427,793899,967054,380033,939384,802423,444510,612730,641112,436918,784904,765276,392198,931433,265662,682113,18816,53694,513221,600079,776782,301964,811121,743716,896979,729653,175132,128573,992169,616245,363016,574552,794707,740357,302691,848447,221121,841891,851302,825426,926826,826510,430428,414150,19710,329138) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001074s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1042262 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1042262 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000405s ]