SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 198401 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 198401 [ RunTime:0.001713s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (531787,53041,713063,871690,404455,146079,694541,95717,827237,249848,46299,266020,934181,570703,78773,927131,829913,184615,857591,690461,59208,353623,1000632,461641,639644,779411,473396,316342,834927,487957,626824,427474,427708,24507,767833,859689,234416,1026497,689704,465309,1043517,202404,744202,776800,652349,313060,211716,805182,140327,374797,537840,572985,123381,144633,774623,536612,321240,753705,421426,379865) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001040s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 198401 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000433s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 198401 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001560s ]