SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001248s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 942014 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 942014 [ RunTime:0.001720s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (710993,315195,911884,383414,604150,1011734,632165,520718,178745,395392,816481,82223,157316,97187,148558,381345,677567,923012,28743,81671,889955,409726,246398,974934,312161,652169,459305,240522,284527,837792,63010,429199,246224,471568,827011,475603,274087,1018328,691909,212157,263384,985219,200335,790499,574761,155779,308329,565714,621898,679416,733010,1042117,259869,821843,326678,646277,226942,213892,578759,665457) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000970s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 942014 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 942014 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000678s ]