SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001251s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 192871 LIMIT 1 [ RunTime:0.000387s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 192871 [ RunTime:0.002815s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (509552,175190,1029940,1037104,10550,941435,262810,789846,489185,1012849,591292,59105,504851,346046,1041407,530803,889877,65869,1007834,814968,248022,542822,978009,1047318,118568,890449,846820,155737,908895,648834,831658,271519,855316,585881,192682,130601,499685,467644,454797,1005937,841349,2181,110611,356634,634031,99967,486235,35823,998750,227053,472085,251796,643105,581517,679516,745696,405073,382501,697769,862066) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 192871 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001990s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 192871 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000836s ]