SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001183s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 200451 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 200451 [ RunTime:0.002006s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (37167,980554,542207,363014,92806,386360,393119,829152,204548,819269,67991,119105,532352,638007,892888,733877,588348,316996,241524,327428,3505,375585,694405,185127,358167,968885,842386,841022,86119,823869,356020,991788,960679,696519,697908,1007513,369533,561150,43999,386772,551542,476236,297185,83785,926241,444466,71491,344674,131773,953466,841683,218289,273022,475405,765955,871371,569146,315743,186047,1006567) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 200451 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000456s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 200451 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000514s ]