SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 303411 LIMIT 1 [ RunTime:0.000547s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 303411 [ RunTime:0.004258s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (545394,605442,516753,231055,394489,948061,1019405,523953,735013,488130,188983,708019,903272,688301,29813,56553,705563,551975,599011,605118,697348,775458,577827,572563,451130,960286,383041,830245,108412,552342,6450,1039673,353912,827858,386069,592613,454419,212240,62404,534918,185848,338871,282825,537188,1014179,913336,432097,199793,314777,759099,295628,254815,521265,890454,52044,620224,84193,266318,635530,359484) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 303411 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000453s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 303411 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000569s ]