SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001247s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017991 LIMIT 1 [ RunTime:0.000548s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017991 [ RunTime:0.001802s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (320624,328868,164262,112188,230149,700771,282494,155263,636655,54099,497712,938211,420290,523700,641782,552602,282830,873028,987968,78619,537637,784510,1038683,118126,134999,799461,374304,995251,281934,860451,775026,1033824,576531,868074,274850,346080,714520,1043377,273875,183421,940328,434812,821772,70249,540372,513707,1030651,659679,719295,72323,909197,929503,356801,920312,979789,5416,1038826,745937,799528,771106) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017991 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000462s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017991 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000593s ]