SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001073s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401064 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401064 [ RunTime:0.001536s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (583819,796956,643015,410388,149461,862820,22221,895478,953090,240031,471203,457277,568359,562817,719721,170003,752938,415103,855386,270264,799259,74676,699552,1016060,199089,896172,730882,436150,99471,163590,71134,294238,654836,894040,173836,37130,94210,647929,207509,499332,420588,676118,492823,660150,637216,379069,113528,610583,390575,700894,878878,263927,8195,263979,157630,730854,115266,825264,443491,1043751) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000966s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401064 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401064 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000445s ]