SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001253s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 511892 LIMIT 1 [ RunTime:0.000466s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 511892 [ RunTime:0.002176s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (575536,892258,391688,681012,173193,985448,602679,361640,324306,139707,460569,519966,916863,193027,365826,841736,290634,866576,23535,762342,414449,913045,426340,698342,187478,2428,523085,827341,738387,845458,920348,206462,1012961,343299,316045,1015392,985701,390831,231947,533675,294193,881369,55415,579249,471297,832366,948029,210477,254087,355849,495435,107825,257742,309422,934457,807606,881354,1032942,223242,795021) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002840s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 511892 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000524s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 511892 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000836s ]