SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 941013 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 941013 [ RunTime:0.002101s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (430849,466657,79203,874080,975516,702457,9936,4435,967506,143836,691035,69363,392555,943908,610398,415765,698831,193912,854159,732320,795479,516993,774047,880911,1003771,36923,580949,554654,164581,181266,988727,709012,304017,952800,188049,1030756,647184,787064,952164,78830,625146,948815,421855,409075,359741,720935,155788,399491,884282,152048,918531,5150,181484,231158,969892,512405,166107,566037,1048068,253776) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000976s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 941013 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 941013 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000420s ]