SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001276s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 536227 LIMIT 1 [ RunTime:0.000495s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 536227 [ RunTime:0.002524s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1029262,482386,869598,431190,914639,909711,537522,93910,588294,909084,547046,603785,676508,855849,543957,864846,627875,262474,644391,807638,703472,1027169,680923,442041,298905,506831,106916,313512,858469,347590,125087,1043655,1030193,850095,109417,685084,410282,340751,745188,611377,54000,584791,14842,171782,352793,641998,554228,803036,507116,1008638,425742,363990,368795,429791,490717,948138,217480,701554,647477,839128) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001039s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 536227 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000684s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 536227 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003853s ]