SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 806292 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 806292 [ RunTime:0.003119s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (992771,694098,379437,520684,578237,794552,947050,447243,362596,383326,828151,653929,348,531934,542350,623931,782274,195236,54976,386557,865189,906664,33524,389534,409660,103519,1032489,10544,488001,396516,50778,911155,759997,367026,50913,129355,235888,345348,196238,770938,599129,135776,326836,742419,804565,45245,1044349,872948,500535,215064,571898,368874,809360,809248,56760,13860,376482,379229,466769,410432) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001744s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 806292 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000603s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 806292 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000631s ]