SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001279s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 509494 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 509494 [ RunTime:0.001865s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (400896,870647,389979,701323,918060,931288,394200,367171,149646,898055,71730,189080,699075,477919,251232,167436,1027490,349880,737706,637615,933181,125428,866425,216726,764323,55263,721212,1008929,695148,385776,106186,395355,671825,241815,146142,809638,741374,324182,533974,699180,93413,253742,545354,156297,120955,269262,424528,1026599,388956,137301,835371,355487,611884,790561,55497,964492,164023,764668,469579,786123) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001616s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 509494 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 509494 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000398s ]