SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001205s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 533650 LIMIT 1 [ RunTime:0.000613s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 533650 [ RunTime:0.001896s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (159802,583804,140238,929030,390556,353568,929594,906950,97573,127526,846033,222792,328964,60173,801920,691059,856137,370761,1038491,729946,577259,733319,287953,1034377,346655,938745,56813,177499,547565,899411,379808,225137,313316,806542,331907,896675,1024771,680983,326976,497414,762916,463029,403331,339182,81349,548505,931391,713314,469245,206812,465293,32506,613943,537827,759405,420732,963556,390513,791062,811620) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005255s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 533650 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000567s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 533650 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001369s ]