SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 526241 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 526241 [ RunTime:0.001771s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (936459,285403,640827,555556,334396,100905,252265,17879,158296,442081,642254,112966,269455,281802,493542,242594,373630,70759,823785,343358,1005328,622541,499131,971638,391027,209049,308750,741568,774143,769662,250238,587306,151440,663008,212027,496232,294094,1013182,314527,858969,206471,765,988594,335860,331974,177988,978903,883562,302255,75958,537744,457170,477945,530833,782025,197065,262147,1002718,346456,987049) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001270s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 526241 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000506s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 526241 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000587s ]