SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001361s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 971801 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 971801 [ RunTime:0.001489s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (112033,648990,108730,624673,120346,289439,103579,244568,989561,526822,487567,519438,478368,539915,695995,589417,434413,791374,325871,184383,802815,962318,987348,69378,997515,498389,540574,864683,144076,960035,286986,13879,376858,13409,76340,817588,4569,44077,584755,125662,31431,323766,319824,281911,31513,757102,189913,89683,389855,877806,227753,809390,952078,523401,862223,893555,187085,855285,411243,867118) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004953s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 971801 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000566s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 971801 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001330s ]