SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001321s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 563810 LIMIT 1 [ RunTime:0.000392s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 563810 [ RunTime:0.001502s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1028140,355871,101770,97037,137390,459600,362826,723113,585541,957361,928374,1029439,484394,285341,7321,397714,42630,552146,745397,668258,741067,174442,379452,39423,354721,313203,762012,641581,271609,699216,927042,385949,977135,303601,1948,1043924,676062,78581,812660,663379,499091,444791,1039144,296173,268472,808696,498625,435369,123358,641123,352691,210651,824798,42643,383266,983482,1041781,844115,1042365,484174) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001048s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 563810 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000632s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 563810 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000568s ]