SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 20163 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 20163 [ RunTime:0.001871s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (732180,283265,469234,297113,583403,561702,576737,996127,61949,892157,945757,619029,325133,280975,830297,48882,815973,679449,481496,213811,479944,506049,136912,830712,116822,357746,668893,297713,50376,445310,462749,1040393,537479,743357,840470,151500,444590,403451,773107,750080,968148,599233,691740,101610,243014,181891,243012,230021,574356,988873,1020011,547066,110610,429702,894192,958024,950812,861914,844459,829465) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002149s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 20163 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000484s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 20163 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000573s ]