SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001290s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 438271 LIMIT 1 [ RunTime:0.000463s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 438271 [ RunTime:0.001849s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (272998,935679,631096,642750,50909,339281,534433,767486,474462,559085,561494,498443,499589,121971,537132,1025063,296896,97211,413723,1022947,834418,493443,259506,164402,480257,289738,83184,69938,677180,743198,383498,709875,485814,754227,730088,343520,125924,917821,764709,360575,249092,413117,324938,765970,433025,181361,143547,990279,376641,880866,30552,265265,834874,169393,126083,126964,85771,402972,116464,699686) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001075s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 438271 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000485s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 438271 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]