SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001249s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 419769 LIMIT 1 [ RunTime:0.000689s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 419769 [ RunTime:0.001686s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (733372,473335,970124,501392,461670,592549,781996,352915,1007668,724190,694893,1048348,834203,720951,968390,128604,55102,941617,944911,237802,539230,248527,690488,558293,164582,660912,154450,34699,814234,374015,510179,496836,405816,632936,659226,551661,265470,978766,179702,238046,497203,915634,911602,1001866,37554,226020,878541,722106,708747,578408,403100,625465,660774,111763,917240,299836,252192,126174,189678,43217) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002634s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 419769 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001910s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 419769 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000619s ]