SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001109s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 731001 LIMIT 1 [ RunTime:0.000282s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 731001 [ RunTime:0.001910s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (30422,625255,61279,453574,784012,676934,146143,4211,811200,6715,747860,443221,709002,226866,597054,926474,371178,1000152,342178,702246,124410,222034,420595,404348,574050,906480,849737,384949,465408,1034977,17274,720744,946756,46682,636942,649296,804808,120408,723889,55101,604406,555363,555113,896238,139144,28068,8338,922089,507450,792134,716195,389679,576347,762163,345047,210107,200214,129954,901891,282920) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000925s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 731001 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 731001 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000686s ]